Formula 10

Operators/Functions Used

If-Then-Else, Not, DayOfWeek, Make Range (to), In Range (in), Parentheses ()

Formula Purpose

A seven day per week customer service department logs all calls and stores the records in a database. As an aid in scheduling weekend staff, management wants to flag the weekend calls so they stand out in the call report.

Formula

If Not(DayOfWeek({file.CALL DATE}) in 2 to 6) Then
    "Weekend"
Else
    ""

Result

Day of Week # Flag

Sunday

1

Weekend

Monday

2


Tuesday

3


Wednesday

4


Thursday

5


Friday

6


Saturday

7

Weekend

Explanation

Related topics

Formulas in action



Seagate Software IMG Holdings, Inc.
http://www.seagatesoftware.com
Support services:
http://support.seagatesoftware.com